#Load libraries
library(readr)
library(dplyr)
# Load the datasets
amazon_sale_report <- read.csv("dataset/Amazon Sale Report.csv", header = TRUE , stringsAsFactors = FALSE)
Product_dataset <- read.csv('dataset/Products.csv', header = TRUE , stringsAsFactors = FALSE)
amazon_products <- read.csv('dataset/Amazon-Products.csv', header = TRUE , stringsAsFactors = FALSE)
# Combine datasets
combined_Product_sale <- inner_join(Product_dataset, amazon_sale_report, by = "Category")
combined_sale_products <- inner_join(combined_Product_sale, amazon_products, by = "index")
#View the dataset
head(combined_sale_products) id Category Rating maincateg platform actprice1 norating1
1 2242 Casuals For Men (Blue) 3.8 Men Flipkart 999 27928
2 2242 Casuals For Men (Blue) 3.8 Men Flipkart 999 27928
3 2242 Casuals For Men (Blue) 3.8 Men Flipkart 999 27928
4 20532 Women Black Flats Sandal 3.9 Women Flipkart 499 3015
5 20532 Women Black Flats Sandal 3.9 Women Flipkart 499 3015
6 20532 Women Black Flats Sandal 3.9 Women Flipkart 499 3015
noreviews1 star_5f star_4f star_3f star_2f star_1f fulfilled1 index
1 3543 14238 4295 3457 1962 3976 1 0
2 3543 14238 4295 3457 1962 3976 1 0
3 3543 14238 4295 3457 1962 3976 1 3190
4 404 1458 657 397 182 321 1 1
5 404 1458 657 397 182 321 1 1
6 404 1458 657 397 182 321 1 39
Order.ID Date Status Fulfilment
1 405-8078784-5731545 4/30/2022 Cancelled Merchant
2 405-8078784-5731545 4/30/2022 Cancelled Merchant
3 171-8820044-0821917 4/28/2022 Shipped Amazon
4 171-9198151-1101146 4/30/2022 Shipped - Delivered to Buyer Merchant
5 171-9198151-1101146 4/30/2022 Shipped - Delivered to Buyer Merchant
6 403-4242957-8599555 4/30/2022 Shipped Amazon
Sales.Channel ship.service.level Style SKU Size ASIN
1 Amazon.in Standard SET389 SET389-KR-NP-S S B09KXVBD7Z
2 Amazon.in Standard SET389 SET389-KR-NP-S S B09KXVBD7Z
3 Amazon.in Expedited JNE3463 JNE3463-KR-XXL XXL B08RP77NWN
4 Amazon.in Standard JNE3781 JNE3781-KR-XXXL 3XL B09K3WFS32
5 Amazon.in Standard JNE3781 JNE3781-KR-XXXL 3XL B09K3WFS32
6 Amazon.in Expedited JNE3405 JNE3405-KR-L L B081WSCKPQ
Courier.Status Qty currency Amount ship.city ship.state
1 0 INR 647.62 MUMBAI MAHARASHTRA
2 0 INR 647.62 MUMBAI MAHARASHTRA
3 Shipped 1 INR 534.00 THANE MAHARASHTRA
4 Shipped 1 INR 406.00 BENGALURU KARNATAKA
5 Shipped 1 INR 406.00 BENGALURU KARNATAKA
6 Shipped 1 INR 399.00 THIRUVANANTHAPURAM KERALA
ship.postal.code ship.country
1 400081 IN
2 400081 IN
3 400607 IN
4 560085 IN
5 560085 IN
6 695011 IN
promotion.ids
1
2
3
4 Amazon PLCC Free-Financing Universal Merchant AAT-WNKTBO3K27EJC,Amazon PLCC Free-Financing Universal Merchant AAT-QX3UCCJESKPA2,Amazon PLCC Free-Financing Universal Merchant AAT-5QQ7BIYYQEDN2,Amazon PLCC Free-Financing Universal Merchant AAT-DSJ2QRXXWXVMQ,Amazon PLCC Free-Financing Universal Merchant AAT-CXJHMC2YJUK76,Amazon PLCC Free-Financing Universal Merchant AAT-CC4FAVTYR4X7C,Amazon PLCC Free-Financing Universal Merchant AAT-XXRCW6NZEPZI4,Amazon PLCC Free-Financing Universal Merchant AAT-CXNSLNBROFDW4,Amazon PLCC Free-Financing Universal Merchant AAT-R7GXNZWISTRFA,Amazon PLCC Free-Financing Universal Merchant AAT-WSJLDN3X7KEMO,Amazon PLCC Free-Financing Universal Merchant AAT-VL6FGQVGQVXUS,Amazon PLCC Free-Financing Universal Merchant AAT-EOKPWFWYW7Y6I,Amazon PLCC Free-Financing Universal Merchant AAT-ZYL5UPUNW6T62,Amazon PLCC Free-Financing Universal Merchant AAT-XVPICCHRWDCAI,Amazon PLCC Free-Financing Universal Merchant AAT-ETXQ3XXWMRXBG,Amazon PLCC Free-Financing Universal Merchant AAT-7X3XCTYG64VBE,Amazon PLCC Free-Financing Universal Merchant AAT-7CHGD3WTS3MHM,Amazon PLCC Free-Financing Universal Merchant AAT-26ZDKNME27X42,Amazon PLCC Free-Financing Universal Merchant AAT-4ZF5KN6E4LJK4,Amazon PLCC Free-Financing Universal Merchant AAT-7RCXIKUAX7DDY,Amazon PLCC Free-Financing Universal Merchant AAT-BRSZZ45H6MHAO,Amazon PLCC Free-Financing Universal Merchant AAT-MKLXOOZWQL7GO,Amazon PLCC Free-Financing Universal Merchant AAT-CB7UNXEXGIJTC,Amazon PLCC Free-Financing Universal Merchant #MP-gzasho-1593152694811,Amazon PLCC Free-Financing Universal Merchant AAT-WLBA4GZ52EAH4
5 Amazon PLCC Free-Financing Universal Merchant AAT-WNKTBO3K27EJC,Amazon PLCC Free-Financing Universal Merchant AAT-QX3UCCJESKPA2,Amazon PLCC Free-Financing Universal Merchant AAT-5QQ7BIYYQEDN2,Amazon PLCC Free-Financing Universal Merchant AAT-DSJ2QRXXWXVMQ,Amazon PLCC Free-Financing Universal Merchant AAT-CXJHMC2YJUK76,Amazon PLCC Free-Financing Universal Merchant AAT-CC4FAVTYR4X7C,Amazon PLCC Free-Financing Universal Merchant AAT-XXRCW6NZEPZI4,Amazon PLCC Free-Financing Universal Merchant AAT-CXNSLNBROFDW4,Amazon PLCC Free-Financing Universal Merchant AAT-R7GXNZWISTRFA,Amazon PLCC Free-Financing Universal Merchant AAT-WSJLDN3X7KEMO,Amazon PLCC Free-Financing Universal Merchant AAT-VL6FGQVGQVXUS,Amazon PLCC Free-Financing Universal Merchant AAT-EOKPWFWYW7Y6I,Amazon PLCC Free-Financing Universal Merchant AAT-ZYL5UPUNW6T62,Amazon PLCC Free-Financing Universal Merchant AAT-XVPICCHRWDCAI,Amazon PLCC Free-Financing Universal Merchant AAT-ETXQ3XXWMRXBG,Amazon PLCC Free-Financing Universal Merchant AAT-7X3XCTYG64VBE,Amazon PLCC Free-Financing Universal Merchant AAT-7CHGD3WTS3MHM,Amazon PLCC Free-Financing Universal Merchant AAT-26ZDKNME27X42,Amazon PLCC Free-Financing Universal Merchant AAT-4ZF5KN6E4LJK4,Amazon PLCC Free-Financing Universal Merchant AAT-7RCXIKUAX7DDY,Amazon PLCC Free-Financing Universal Merchant AAT-BRSZZ45H6MHAO,Amazon PLCC Free-Financing Universal Merchant AAT-MKLXOOZWQL7GO,Amazon PLCC Free-Financing Universal Merchant AAT-CB7UNXEXGIJTC,Amazon PLCC Free-Financing Universal Merchant #MP-gzasho-1593152694811,Amazon PLCC Free-Financing Universal Merchant AAT-WLBA4GZ52EAH4
6
B2B fulfilled.by
1 FALSE Easy Ship
2 FALSE Easy Ship
3 FALSE
4 FALSE Easy Ship
5 FALSE Easy Ship
6 FALSE
name
1 Lloyd 1.5 Ton 3 Star Inverter Split Ac (5 In 1 Convertible, Copper, Anti-Viral + Pm 2.5 Filter, 2023 Model, White, Gls18I3...
2 Pigeon by Stovekraft Amaze Plus Electric Kettle (14289) with Stainless Steel Body, 1.5 litre, used for boiling Water, maki...
3 IFB Filterless ChimneyGL-HC-105-60) with Handsensor & Easy Heat Clean
4 LG 1.5 Ton 5 Star AI DUAL Inverter Split AC (Copper, Super Convertible 6-in-1 Cooling, HD Filter with Anti-Virus Protectio...
5 Pigeon Polypropylene Mini Handy and Compact Chopper with 3 Blades for Effortlessly Chopping Vegetables and Fruits for Your...
6 Panasonic 1.5 Ton 3 Star Wi-Fi Inverter Smart Split AC (Copper Condenser, 7 in 1 Convertible with additional AI Mode, PM ...
main_category sub_category
1 appliances Air Conditioners
2 appliances All Appliances
3 appliances All Appliances
4 appliances Air Conditioners
5 appliances All Appliances
6 appliances Air Conditioners
image
1 https://m.media-amazon.com/images/I/31UISB90sYL._AC_UL320_.jpg
2 https://m.media-amazon.com/images/W/IMAGERENDERING_521856-T1/images/I/51DGcy8eBCL._AC_UL320_.jpg
3 https://m.media-amazon.com/images/I/61X5d95OHcL._AC_UL320_.jpg
4 https://m.media-amazon.com/images/I/51JFb7FctDL._AC_UL320_.jpg
5 https://m.media-amazon.com/images/W/IMAGERENDERING_521856-T1/images/I/51RXzjrUmkL._AC_UL320_.jpg
6 https://m.media-amazon.com/images/I/61PWjQFDtQL._AC_UL320_.jpg
link
1 https://www.amazon.in/Lloyd-Inverter-Convertible-Anti-Viral-GLS18I3FWAMC/dp/B0BRKXTSBT/ref=sr_1_4?qid=1679134237&s=kitchen&sr=1-4
2 https://www.amazon.in/Pigeon-Amaze-Plus-1-5-Ltr/dp/B07WMS7TWB/ref=sr_1_1?qid=1679135585&s=appliances&sr=1-1
3 https://www.amazon.in/IFB-Auto-Clean-GL-HC-105-60-Filterless-Technology/dp/B08PGY65PQ/ref=sr_1_3191?qid=1679135774&s=appliances&sr=1-3191
4 https://www.amazon.in/LG-Convertible-Anti-Virus-Protection-RS-Q19YNZE/dp/B0BQ3MXML8/ref=sr_1_5?qid=1679134237&s=kitchen&sr=1-5
5 https://www.amazon.in/Pigeon-Stovekraft-Plastic-Chopper-Blades/dp/B01LWYDEQ7/ref=sr_1_2?qid=1679135585&s=appliances&sr=1-2
6 https://www.amazon.in/Panasonic-Convertible-additional-Purification-CU-SU18YKYWT/dp/B0BRJ5QH8G/ref=sr_1_46?qid=1679134239&s=kitchen&sr=1-46
ratings no_of_ratings discount_price actual_price
1 4.2 2,255 ₹32,999 ₹58,990
2 3.9 128,941 ₹599 ₹1,245
3 2 1 ₹29,078 ₹34,490
4 4.2 2,948 ₹46,490 ₹75,990
5 4.1 274,505 ₹199 ₹545
6 4.2 1,830 ₹37,990 ₹55,400